package com.whnk.pm.dto;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import lombok.Data;

import java.util.Date;

@Data
public class ProjectExcelExportDTO {

    @ColumnWidth(18)
    @ExcelProperty(value = "项目编号", index = 0)
    private String projectId;
    @ColumnWidth(18)
    @ExcelProperty(value = "项目名称", index = 1)
    private String projectName;
    @ColumnWidth(18)
    @ExcelProperty(value = "合作公司", index = 2)
    private String cooperativeCompany;
    @ColumnWidth(18)
    @ExcelProperty(value = "项目经理", index = 3)
    private String pmp;
    @ColumnWidth(18)
    @ExcelProperty(value = "预算下达情况", index = 4)
    private String budgetStatus;
    @ColumnWidth(18)
    @ExcelProperty(value = "所属处室", index = 5)
    private String department;
    @ColumnWidth(18)
    @ExcelProperty(value = "项目状态", index = 6)
    private String projectStatus;

    @ColumnWidth(18)
    @DateTimeFormat("yyyy-MM-dd")
    @ExcelProperty(value = "开始日期", index = 7)
    private Date startTime;
    @ColumnWidth(18)
    @DateTimeFormat("yyyy-MM-dd")
    @ExcelProperty(value = "结束日期", index = 8)
    private Date endTime;

    @ColumnWidth(9)
    @ExcelProperty(value = "项目周数", index = 9)
    private String budgetCycle;

    @ColumnWidth(9)
    @ExcelProperty(value = "目前周数", index = 10)
    private String currentWeek;
    @ColumnWidth(9)
    @ExcelProperty(value = "时间进度", index = 11)
    private String timeSchedule;

    @ColumnWidth(18)
    @ExcelProperty(value = "人员资质", index = 12)
    private String personnelQualification;

    @ColumnWidth(9)
    @ExcelProperty(value = {"采购资源","工作量"}, index = 13)
    private String workload;
    @ColumnWidth(9)
    @ExcelProperty(value = {"采购资源","人数"}, index = 14)
    private Integer peopleNumber;

    @ColumnWidth(9)
    @ExcelProperty(value = {"在场人数"}, index = 15)
    private Integer peopleNumberPresent;

    @ColumnWidth(9)
    @ExcelProperty(value = "已使用工作量", index = 16)
    private String usedWorkload;
    @ColumnWidth(9)
    @ExcelProperty(value = "上周考勤", index = 17)
    private String addendLastWeek;

    @ColumnWidth(9)
    @ExcelProperty(value = {"资源使用率项目时间进度百分比差额","滞后"}, index = 18)
    private String lag;
    @ColumnWidth(9)
    @ExcelProperty(value = {"资源使用率项目时间进度百分比差额","超前"}, index = 19)
    private String pullAhead;

    @ColumnWidth(9)
    @ExcelProperty(value = "总资源使用率", index = 20)
    private String totalResourceUtilization;

    @ColumnWidth(18)
    @ExcelProperty(value = {"预估5个工作日后","已使用工作量"}, index = 21)
    private String day_5_workload;
    @ColumnWidth(18)
    @ExcelProperty(value = {"预估5个工作日后","总资源使用率"}, index = 22)
    private String day_5_totalResourceUtilization;

    @ColumnWidth(18)
    @ExcelProperty(value = {"备注"}, index = 23)
    private String remark;
}
